UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VCYxJubVJ0uoOcfjvsEOPq0vEmU79aZhXuozomIsYdI='
WHERE
key_id = '8fb1a934dd4f0cc97b67d14009fbe499ebbb8225fdaf9f46b4b90e09941f635a'
AND (
token = 'VCYxJubVJ0uoOcfjvsEOPq0vEmU79aZhXuozomIsYdI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)