UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U83Fmm3out3ILm1L8PJFZdi4+yghNMaysN4Y0yHwBWk='
WHERE
key_id = 'cb7c18507c0d55d063678c99e0a802ca878acaa7bf16adcf47b21b60eb1ccb5e'
AND (
token = 'U83Fmm3out3ILm1L8PJFZdi4+yghNMaysN4Y0yHwBWk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)