UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TUEvl4TiKFkfDLW1vE1szAfqZqe9Voiji/gCbDDp3eg='
WHERE
key_id = '844c4dbacef2e49920386feb7b70590c81bfa147d9c5b4935a90101ee7fae548'
AND (
token = 'TUEvl4TiKFkfDLW1vE1szAfqZqe9Voiji/gCbDDp3eg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)