UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c8okgHGPHGTIpiHqg4ncFVJU2gUNRzF3mRWkFfBOkbQ='
WHERE
key_id = '538e7b614ef5797db903e4a501e0716227cb438c6b3b0ff765aac2bba77a535a'
AND (
token = 'c8okgHGPHGTIpiHqg4ncFVJU2gUNRzF3mRWkFfBOkbQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)