UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8XwL7YQMvSnUuZu92OK7Bd7UDv1XINd+6smaWoXvV60='
WHERE
key_id = '2111f568378c82aef8b8afd6e740aab91445afd2c102ac563b1fe605a6d6a06d'
AND (
token = '8XwL7YQMvSnUuZu92OK7Bd7UDv1XINd+6smaWoXvV60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)