UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9vKnS/8djqXGRgYcO6n0P0QmpjvU17Hk6bhdzYwsXls='
WHERE
key_id = '5e4fae1e34ebb9798ddcff688ecae342a79ad0896955cbf56e1eb28dce78b7a9'
AND (
token = '9vKnS/8djqXGRgYcO6n0P0QmpjvU17Hk6bhdzYwsXls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)