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