UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pfPwMehcMiYcRK8eaTfH+d+6SnT6+s1ZpULfsdXV2HU='
WHERE
key_id = 'df782733802010ffc41ab73fc4be890b7a58466b36e2ec5ef8e875712dd61372'
AND (
token = 'pfPwMehcMiYcRK8eaTfH+d+6SnT6+s1ZpULfsdXV2HU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)