UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vHcwGwJaDtz4rEUxfbchHZeus0L0kqb9VEk4qG8QzXk='
WHERE
key_id = '84cb527cf380cd1a690a2716b1a9e375e9a82954faf4b7f1c753362e689107bd'
AND (
token = 'vHcwGwJaDtz4rEUxfbchHZeus0L0kqb9VEk4qG8QzXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)