UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/zRAtE50d4J41dZi2Z/8JJvr5nSNaftR+7cGhAGMeyc='
WHERE
key_id = 'beba810e1e0d591754d1ce04dc58594fd6a4a26c9d292f042e7f290c69b1ed10'
AND (
token = '/zRAtE50d4J41dZi2Z/8JJvr5nSNaftR+7cGhAGMeyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)