UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EiFguvCkUk0DTXN7svtf+X3CGhk1tTLhtvQv99VJcTU='
WHERE
key_id = 'a9de6a221fd55e401455fe3419d55337c89834830d26241c09e1bce3248ec814'
AND (
token = 'EiFguvCkUk0DTXN7svtf+X3CGhk1tTLhtvQv99VJcTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)