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