UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8zpKnwYC4C7dHsa3dB6Re6LBM9KJXrNqMco+kwjcYYY='
WHERE
key_id = '6d394a271007e5a573b0acfb2e2fc31b5d05f10b66435cf157f2425d7e872384'
AND (
token = '8zpKnwYC4C7dHsa3dB6Re6LBM9KJXrNqMco+kwjcYYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)