UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+k9pNwoRFOO4SsvSKtweElnG+reJUxN7iUnOeW3egvU='
WHERE
key_id = 'b71f3ffe2153b5f49172b2326556c98195f0915f417428fe4e4c5659c7df9780'
AND (
token = '+k9pNwoRFOO4SsvSKtweElnG+reJUxN7iUnOeW3egvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)