UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6HJ/1Vb27jECRwO7LV2abrn7ysU4HOUaRBrC+4FSfls='
WHERE
key_id = '8d21800d3e37d834ad853073b5b4ae94131377bdd6ff5b6770ea6b498c684b49'
AND (
token = '6HJ/1Vb27jECRwO7LV2abrn7ysU4HOUaRBrC+4FSfls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)