UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P7dfb02pYzHaFvahZ5Npb0M5vxHZF2U8k6OrU3PZNu8='
WHERE
key_id = '17de04fd741ed22f8ca39d86e0a1fb92e2ad698bfd72f5e5929d23bd5772bf5b'
AND (
token = 'P7dfb02pYzHaFvahZ5Npb0M5vxHZF2U8k6OrU3PZNu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)