UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tFt3PQGrznFa3SlcElQ1u4jV1jUwy1OZfFwLo7zorgg='
WHERE
key_id = 'a56b4b1547b5699f2a9dc5ad009410bb6f0a1a5da5c8441df269c94ee6aab9aa'
AND (
token = 'tFt3PQGrznFa3SlcElQ1u4jV1jUwy1OZfFwLo7zorgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)