UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8uLZSiihhukLieG8+a2eHQZ7SGoqgoxEZqlixmPsYxQ='
WHERE
key_id = '29a7a4c12bc2a5f28ffea1703af085a7cd4c8bba4f3d31353ed9cf8df18dc07a'
AND (
token = '8uLZSiihhukLieG8+a2eHQZ7SGoqgoxEZqlixmPsYxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)