UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K7TuZi+ePhqJLChXmy5kzDj3S9Hv7QLCaxUPYRiIRmo='
WHERE
key_id = 'e1784c4f27ae9a12dc028cf2ca381b45d685ddea3fcc6b3c23ab59f1389f235c'
AND (
token = 'K7TuZi+ePhqJLChXmy5kzDj3S9Hv7QLCaxUPYRiIRmo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)