UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MaE5fMtYfqMZf2ZHJh1svv5X9C7nhqhWe8a5R645Ld8='
WHERE
key_id = '99c90ecc6936c5e6f1e5995ad009de1d84adb44d1bc55c625714e37f82b2245d'
AND (
token = 'MaE5fMtYfqMZf2ZHJh1svv5X9C7nhqhWe8a5R645Ld8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)