UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '36O1/tQm6wh6NKM5Hau3UkHMwVdMvASeLqVKioV9j2E='
WHERE
key_id = 'cd0047d5b1e0a0368b66ac46d419ffd1f87cb196d3613437d2ed62da428bd610'
AND (
token = '36O1/tQm6wh6NKM5Hau3UkHMwVdMvASeLqVKioV9j2E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)