UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KAvAi1x/qrDQuQyvWDA6lszDdM0crbvwMk8PPWPHDZs='
WHERE
key_id = '5b6a8462785608a4e1fb2bd87f00dd13da59843959b341fd572b7a3ad41604ab'
AND (
token = 'KAvAi1x/qrDQuQyvWDA6lszDdM0crbvwMk8PPWPHDZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)