UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NhKUwlhqvyNecZmmnAvtiJi2ZFFAng8G5bU1T28PQKA='
WHERE
key_id = 'b7b7b94c28f9784d3cd7caafee5a15abe37dbefc0784938d3682139d7b278857'
AND (
token = 'NhKUwlhqvyNecZmmnAvtiJi2ZFFAng8G5bU1T28PQKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)