UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u0zKG4N3yL3i0oiBRldfvctjoONChGpSpvv6+dHSQW8='
WHERE
key_id = 'd32fcc5b40a58629a19bcae7ff978496361f8eb902cb1dbea45c01a1a0faa095'
AND (
token = 'u0zKG4N3yL3i0oiBRldfvctjoONChGpSpvv6+dHSQW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)