UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LjiWIbEdidTnkX2Lx0r5k67laS+INXHF+dFwdyix+yY='
WHERE
key_id = '24e18cfad0bd17403f5f31b8f31c6651ec2c7f44ca9a77d8a24ef89e34c0a551'
AND (
token = 'LjiWIbEdidTnkX2Lx0r5k67laS+INXHF+dFwdyix+yY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)