UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kRmPZNWnjwFrdzI+l2E47eM3Me99tNgxYc9diTdCrH0='
WHERE
key_id = 'c5e8b4979b83afa3c849c0e9721e28fe9c96367f24fff3f6a52ee7ae63536599'
AND (
token = 'kRmPZNWnjwFrdzI+l2E47eM3Me99tNgxYc9diTdCrH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)