UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dP+f3Ch9oU0QmffMCNpGKxtT248fKg7tvNW9YVs7PTo='
WHERE
key_id = 'd7b809d066e7189b093ff66cf26019d3ba717864c659047a274a8109dfacc0d7'
AND (
token = 'dP+f3Ch9oU0QmffMCNpGKxtT248fKg7tvNW9YVs7PTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)