UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SECzUkbbnXBzwWDTbVwF81TfDzHrFhiu3jEnNpKxWX8='
WHERE
key_id = 'bb9d34a2b494632025abcfa5fc138b5aba5cc9d84c53e072198b780faecb77e5'
AND (
token = 'SECzUkbbnXBzwWDTbVwF81TfDzHrFhiu3jEnNpKxWX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)