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