UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qDs3ggPTgo04c4QVB7VS/dmN3QKbdz99d45lo1eH0r8='
WHERE
key_id = 'bdc2e3760ffa1fde7409520aea379adaaa7a6f471e4736329668eec305e926b0'
AND (
token = 'qDs3ggPTgo04c4QVB7VS/dmN3QKbdz99d45lo1eH0r8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)