UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0nF2f5ZyvU26Ery1p5I7wiHS8TG0pNXLBzq2R8PMg7E='
WHERE
key_id = 'bc64f82719197208644f4242520e41fd771647f6ac68e05c701accb6cfd47fb5'
AND (
token = '0nF2f5ZyvU26Ery1p5I7wiHS8TG0pNXLBzq2R8PMg7E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)