UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ODc9XEZT8wQRUyWzPzBswDCLy7qie0njcGa39pHrBbk='
WHERE
key_id = '36416f37bc5c7ea3cb8d2f825d3add1272bf58628be03c37eb4b21ae96ef7994'
AND (
token = 'ODc9XEZT8wQRUyWzPzBswDCLy7qie0njcGa39pHrBbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)