UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/R7kNYnNkCbIJtJl1vilK77UfyGDcS9YnhAsZ7WJjjI='
WHERE
key_id = '786f190014a34ca2303231ac83f5d6eef7fba8a7bf6b170b12f1f6e738d2aee8'
AND (
token = '/R7kNYnNkCbIJtJl1vilK77UfyGDcS9YnhAsZ7WJjjI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)