UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fqH65iiMwF3oIgpxfvkltzehNLVIBC9t7UWorqrynuA='
WHERE
key_id = '3088767b3d7f5c211c1c7a2a76a13899e41c5d239564ee3a5f63de3d3ec061c8'
AND (
token = 'fqH65iiMwF3oIgpxfvkltzehNLVIBC9t7UWorqrynuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)