UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oU9WP9bFz73CR3+NxBZJda9r6pIzL5UtyU+ZIbYTNIo='
WHERE
key_id = '9fc97596b2a6106ce00917fdc78fa8f8458d80636da8b505febcec0f1c6a66dd'
AND (
token = 'oU9WP9bFz73CR3+NxBZJda9r6pIzL5UtyU+ZIbYTNIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)