UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BOn5ojt5j1DqG303oWfH4sKT/5nlMs3SpnrpFkBAPKg='
WHERE
key_id = 'bef4823b0122f18fd58ade3165dc5adb928faeec40fc5df6e9acea1f9bef2b65'
AND (
token = 'BOn5ojt5j1DqG303oWfH4sKT/5nlMs3SpnrpFkBAPKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)