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